{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "fa1b6b6f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gaze_timestamp</th>\n",
       "      <th>world_index</th>\n",
       "      <th>confidence</th>\n",
       "      <th>norm_pos_x</th>\n",
       "      <th>norm_pos_y</th>\n",
       "      <th>base_data</th>\n",
       "      <th>gaze_point_3d_x</th>\n",
       "      <th>gaze_point_3d_y</th>\n",
       "      <th>gaze_point_3d_z</th>\n",
       "      <th>eye_center0_3d_x</th>\n",
       "      <th>...</th>\n",
       "      <th>eye_center0_3d_z</th>\n",
       "      <th>gaze_normal0_x</th>\n",
       "      <th>gaze_normal0_y</th>\n",
       "      <th>gaze_normal0_z</th>\n",
       "      <th>eye_center1_3d_x</th>\n",
       "      <th>eye_center1_3d_y</th>\n",
       "      <th>eye_center1_3d_z</th>\n",
       "      <th>gaze_normal1_x</th>\n",
       "      <th>gaze_normal1_y</th>\n",
       "      <th>gaze_normal1_z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>88150.776780</td>\n",
       "      <td>0</td>\n",
       "      <td>0.828006</td>\n",
       "      <td>0.531433</td>\n",
       "      <td>0.397509</td>\n",
       "      <td>88150.77678-0</td>\n",
       "      <td>28.369753</td>\n",
       "      <td>52.033135</td>\n",
       "      <td>705.121116</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.011527</td>\n",
       "      <td>0.051002</td>\n",
       "      <td>0.998632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>88150.776787</td>\n",
       "      <td>0</td>\n",
       "      <td>0.459705</td>\n",
       "      <td>0.337051</td>\n",
       "      <td>0.186147</td>\n",
       "      <td>88150.776787-1</td>\n",
       "      <td>-142.869866</td>\n",
       "      <td>154.788121</td>\n",
       "      <td>684.981621</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.141761</td>\n",
       "      <td>0.192518</td>\n",
       "      <td>0.971000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>88150.779709</td>\n",
       "      <td>0</td>\n",
       "      <td>0.888789</td>\n",
       "      <td>0.543140</td>\n",
       "      <td>0.410668</td>\n",
       "      <td>88150.779709-0</td>\n",
       "      <td>38.942051</td>\n",
       "      <td>45.359863</td>\n",
       "      <td>705.232112</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.026087</td>\n",
       "      <td>0.041811</td>\n",
       "      <td>0.998785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>88150.779759</td>\n",
       "      <td>0</td>\n",
       "      <td>0.550258</td>\n",
       "      <td>0.337923</td>\n",
       "      <td>0.173301</td>\n",
       "      <td>88150.779759-1</td>\n",
       "      <td>-141.879169</td>\n",
       "      <td>160.867779</td>\n",
       "      <td>683.893108</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.140397</td>\n",
       "      <td>0.200891</td>\n",
       "      <td>0.969501</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>88150.787485</td>\n",
       "      <td>1</td>\n",
       "      <td>0.502595</td>\n",
       "      <td>0.340109</td>\n",
       "      <td>0.142989</td>\n",
       "      <td>88150.787485-1</td>\n",
       "      <td>-139.404860</td>\n",
       "      <td>175.088321</td>\n",
       "      <td>681.151453</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.136989</td>\n",
       "      <td>0.220475</td>\n",
       "      <td>0.965725</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125259</th>\n",
       "      <td>88443.695600</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.995336</td>\n",
       "      <td>0.407831</td>\n",
       "      <td>0.413470</td>\n",
       "      <td>88443.69561-0 88443.695591-1</td>\n",
       "      <td>327.648915</td>\n",
       "      <td>-173.027524</td>\n",
       "      <td>-2777.243340</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.130868</td>\n",
       "      <td>0.093021</td>\n",
       "      <td>0.987026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125260</th>\n",
       "      <td>88443.697570</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.948733</td>\n",
       "      <td>0.407552</td>\n",
       "      <td>0.414731</td>\n",
       "      <td>88443.69561-0 88443.69953099999-1</td>\n",
       "      <td>311.054477</td>\n",
       "      <td>-161.381388</td>\n",
       "      <td>-2628.637408</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125261</th>\n",
       "      <td>88443.701580</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407467</td>\n",
       "      <td>0.414705</td>\n",
       "      <td>88443.703629-0 88443.69953099999-1</td>\n",
       "      <td>313.566509</td>\n",
       "      <td>-162.585330</td>\n",
       "      <td>-2647.420719</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125262</th>\n",
       "      <td>88443.703608</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407160</td>\n",
       "      <td>0.415340</td>\n",
       "      <td>88443.703629-0 88443.703587-1</td>\n",
       "      <td>297.019831</td>\n",
       "      <td>-152.352987</td>\n",
       "      <td>-2499.428189</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.133311</td>\n",
       "      <td>0.091656</td>\n",
       "      <td>0.986827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125263</th>\n",
       "      <td>88443.705574</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407637</td>\n",
       "      <td>0.413674</td>\n",
       "      <td>88443.703629-0 88443.70751899999-1</td>\n",
       "      <td>323.629974</td>\n",
       "      <td>-170.142461</td>\n",
       "      <td>-2737.404466</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.131320</td>\n",
       "      <td>0.092941</td>\n",
       "      <td>0.986974</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125264 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
       "0         88150.776780            0    0.828006    0.531433    0.397509   \n",
       "1         88150.776787            0    0.459705    0.337051    0.186147   \n",
       "2         88150.779709            0    0.888789    0.543140    0.410668   \n",
       "3         88150.779759            0    0.550258    0.337923    0.173301   \n",
       "4         88150.787485            1    0.502595    0.340109    0.142989   \n",
       "...                ...          ...         ...         ...         ...   \n",
       "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
       "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
       "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
       "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
       "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
       "\n",
       "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
       "0                            88150.77678-0        28.369753        52.033135   \n",
       "1                           88150.776787-1      -142.869866       154.788121   \n",
       "2                           88150.779709-0        38.942051        45.359863   \n",
       "3                           88150.779759-1      -141.879169       160.867779   \n",
       "4                           88150.787485-1      -139.404860       175.088321   \n",
       "...                                    ...              ...              ...   \n",
       "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
       "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
       "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
       "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
       "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
       "\n",
       "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
       "0            705.121116         20.000000  ...        -20.000000   \n",
       "1            684.981621        -39.934928  ...        -20.075283   \n",
       "2            705.232112         20.000000  ...        -20.000000   \n",
       "3            683.893108        -39.934928  ...        -20.075283   \n",
       "4            681.151453        -39.934928  ...        -20.075283   \n",
       "...                 ...               ...  ...               ...   \n",
       "125259     -2777.243340         19.888755  ...        -20.707271   \n",
       "125260     -2628.637408         19.888755  ...        -20.707271   \n",
       "125261     -2647.420719         19.888755  ...        -20.707271   \n",
       "125262     -2499.428189         19.888755  ...        -20.707271   \n",
       "125263     -2737.404466         19.888755  ...        -20.707271   \n",
       "\n",
       "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
       "0             0.011527        0.051002        0.998632               NaN   \n",
       "1            -0.141761        0.192518        0.971000               NaN   \n",
       "2             0.026087        0.041811        0.998785               NaN   \n",
       "3            -0.140397        0.200891        0.969501               NaN   \n",
       "4            -0.136989        0.220475        0.965725               NaN   \n",
       "...                ...             ...             ...               ...   \n",
       "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
       "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
       "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
       "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
       "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
       "\n",
       "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
       "0                    NaN               NaN             NaN             NaN   \n",
       "1                    NaN               NaN             NaN             NaN   \n",
       "2                    NaN               NaN             NaN             NaN   \n",
       "3                    NaN               NaN             NaN             NaN   \n",
       "4                    NaN               NaN             NaN             NaN   \n",
       "...                  ...               ...             ...             ...   \n",
       "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
       "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
       "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
       "\n",
       "        gaze_normal1_z  \n",
       "0                  NaN  \n",
       "1                  NaN  \n",
       "2                  NaN  \n",
       "3                  NaN  \n",
       "4                  NaN  \n",
       "...                ...  \n",
       "125259        0.987026  \n",
       "125260        0.986979  \n",
       "125261        0.986979  \n",
       "125262        0.986827  \n",
       "125263        0.986974  \n",
       "\n",
       "[125264 rows x 21 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd \n",
    "from pandas import Series,DataFrame \n",
    "import numpy as np\n",
    "f=open('C:/Users/23980/Downloads/gaze.csv',encoding='utf-8')\n",
    "df =pd.read_csv(f)\n",
    "display(df)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9678bc8f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gaze_timestamp</th>\n",
       "      <th>world_index</th>\n",
       "      <th>confidence</th>\n",
       "      <th>norm_pos_x</th>\n",
       "      <th>norm_pos_y</th>\n",
       "      <th>base_data</th>\n",
       "      <th>gaze_point_3d_x</th>\n",
       "      <th>gaze_point_3d_y</th>\n",
       "      <th>gaze_point_3d_z</th>\n",
       "      <th>eye_center0_3d_x</th>\n",
       "      <th>...</th>\n",
       "      <th>eye_center0_3d_z</th>\n",
       "      <th>gaze_normal0_x</th>\n",
       "      <th>gaze_normal0_y</th>\n",
       "      <th>gaze_normal0_z</th>\n",
       "      <th>eye_center1_3d_x</th>\n",
       "      <th>eye_center1_3d_y</th>\n",
       "      <th>eye_center1_3d_z</th>\n",
       "      <th>gaze_normal1_x</th>\n",
       "      <th>gaze_normal1_y</th>\n",
       "      <th>gaze_normal1_z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>88150.825638</td>\n",
       "      <td>2</td>\n",
       "      <td>0.915197</td>\n",
       "      <td>0.493612</td>\n",
       "      <td>0.398950</td>\n",
       "      <td>88150.827729-0 88150.823548-1</td>\n",
       "      <td>2.412810</td>\n",
       "      <td>-21.468145</td>\n",
       "      <td>-295.071057</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.062883</td>\n",
       "      <td>0.025100</td>\n",
       "      <td>0.997705</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.150041</td>\n",
       "      <td>0.234536</td>\n",
       "      <td>0.960458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>88150.827729</td>\n",
       "      <td>2</td>\n",
       "      <td>0.915197</td>\n",
       "      <td>0.493561</td>\n",
       "      <td>0.399305</td>\n",
       "      <td>88150.827729-0 88150.827729-1</td>\n",
       "      <td>2.429837</td>\n",
       "      <td>-21.374413</td>\n",
       "      <td>-294.819200</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.062883</td>\n",
       "      <td>0.025100</td>\n",
       "      <td>0.997705</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.150243</td>\n",
       "      <td>0.234115</td>\n",
       "      <td>0.960530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>88150.829663</td>\n",
       "      <td>2</td>\n",
       "      <td>0.915197</td>\n",
       "      <td>0.493570</td>\n",
       "      <td>0.399542</td>\n",
       "      <td>88150.827729-0 88150.83159799999-1</td>\n",
       "      <td>2.427118</td>\n",
       "      <td>-21.328193</td>\n",
       "      <td>-294.874516</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.062883</td>\n",
       "      <td>0.025100</td>\n",
       "      <td>0.997705</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.150210</td>\n",
       "      <td>0.233747</td>\n",
       "      <td>0.960624</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>88150.866015</td>\n",
       "      <td>3</td>\n",
       "      <td>0.922197</td>\n",
       "      <td>0.492592</td>\n",
       "      <td>0.398705</td>\n",
       "      <td>88150.867514-0 88150.86451599999-1</td>\n",
       "      <td>2.827911</td>\n",
       "      <td>-21.750938</td>\n",
       "      <td>-298.233245</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.060717</td>\n",
       "      <td>0.025220</td>\n",
       "      <td>0.997836</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.149814</td>\n",
       "      <td>0.233510</td>\n",
       "      <td>0.960744</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>88150.869620</td>\n",
       "      <td>3</td>\n",
       "      <td>0.922197</td>\n",
       "      <td>0.492635</td>\n",
       "      <td>0.398814</td>\n",
       "      <td>88150.867514-0 88150.871726-1</td>\n",
       "      <td>2.813774</td>\n",
       "      <td>-21.744854</td>\n",
       "      <td>-298.471253</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.060717</td>\n",
       "      <td>0.025220</td>\n",
       "      <td>0.997836</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.149645</td>\n",
       "      <td>0.233258</td>\n",
       "      <td>0.960831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125259</th>\n",
       "      <td>88443.695600</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.995336</td>\n",
       "      <td>0.407831</td>\n",
       "      <td>0.413470</td>\n",
       "      <td>88443.69561-0 88443.695591-1</td>\n",
       "      <td>327.648915</td>\n",
       "      <td>-173.027524</td>\n",
       "      <td>-2777.243340</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.130868</td>\n",
       "      <td>0.093021</td>\n",
       "      <td>0.987026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125260</th>\n",
       "      <td>88443.697570</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.948733</td>\n",
       "      <td>0.407552</td>\n",
       "      <td>0.414731</td>\n",
       "      <td>88443.69561-0 88443.69953099999-1</td>\n",
       "      <td>311.054477</td>\n",
       "      <td>-161.381388</td>\n",
       "      <td>-2628.637408</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125261</th>\n",
       "      <td>88443.701580</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407467</td>\n",
       "      <td>0.414705</td>\n",
       "      <td>88443.703629-0 88443.69953099999-1</td>\n",
       "      <td>313.566509</td>\n",
       "      <td>-162.585330</td>\n",
       "      <td>-2647.420719</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125262</th>\n",
       "      <td>88443.703608</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407160</td>\n",
       "      <td>0.415340</td>\n",
       "      <td>88443.703629-0 88443.703587-1</td>\n",
       "      <td>297.019831</td>\n",
       "      <td>-152.352987</td>\n",
       "      <td>-2499.428189</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.133311</td>\n",
       "      <td>0.091656</td>\n",
       "      <td>0.986827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125263</th>\n",
       "      <td>88443.705574</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407637</td>\n",
       "      <td>0.413674</td>\n",
       "      <td>88443.703629-0 88443.70751899999-1</td>\n",
       "      <td>323.629974</td>\n",
       "      <td>-170.142461</td>\n",
       "      <td>-2737.404466</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.131320</td>\n",
       "      <td>0.092941</td>\n",
       "      <td>0.986974</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>87442 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
       "21        88150.825638            2    0.915197    0.493612    0.398950   \n",
       "22        88150.827729            2    0.915197    0.493561    0.399305   \n",
       "23        88150.829663            2    0.915197    0.493570    0.399542   \n",
       "39        88150.866015            3    0.922197    0.492592    0.398705   \n",
       "40        88150.869620            3    0.922197    0.492635    0.398814   \n",
       "...                ...          ...         ...         ...         ...   \n",
       "125259    88443.695600         8788    0.995336    0.407831    0.413470   \n",
       "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
       "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
       "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
       "125263    88443.705574         8788    0.945284    0.407637    0.413674   \n",
       "\n",
       "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
       "21           88150.827729-0 88150.823548-1         2.412810       -21.468145   \n",
       "22           88150.827729-0 88150.827729-1         2.429837       -21.374413   \n",
       "23      88150.827729-0 88150.83159799999-1         2.427118       -21.328193   \n",
       "39      88150.867514-0 88150.86451599999-1         2.827911       -21.750938   \n",
       "40           88150.867514-0 88150.871726-1         2.813774       -21.744854   \n",
       "...                                    ...              ...              ...   \n",
       "125259        88443.69561-0 88443.695591-1       327.648915      -173.027524   \n",
       "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
       "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
       "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
       "125263  88443.703629-0 88443.70751899999-1       323.629974      -170.142461   \n",
       "\n",
       "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
       "21          -295.071057         20.000000  ...        -20.000000   \n",
       "22          -294.819200         20.000000  ...        -20.000000   \n",
       "23          -294.874516         20.000000  ...        -20.000000   \n",
       "39          -298.233245         20.000000  ...        -20.000000   \n",
       "40          -298.471253         20.000000  ...        -20.000000   \n",
       "...                 ...               ...  ...               ...   \n",
       "125259     -2777.243340         19.888755  ...        -20.707271   \n",
       "125260     -2628.637408         19.888755  ...        -20.707271   \n",
       "125261     -2647.420719         19.888755  ...        -20.707271   \n",
       "125262     -2499.428189         19.888755  ...        -20.707271   \n",
       "125263     -2737.404466         19.888755  ...        -20.707271   \n",
       "\n",
       "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
       "21            0.062883        0.025100        0.997705        -39.934928   \n",
       "22            0.062883        0.025100        0.997705        -39.934928   \n",
       "23            0.062883        0.025100        0.997705        -39.934928   \n",
       "39            0.060717        0.025220        0.997836        -39.934928   \n",
       "40            0.060717        0.025220        0.997836        -39.934928   \n",
       "...                ...             ...             ...               ...   \n",
       "125259       -0.110854        0.041843        0.992955        -37.372594   \n",
       "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
       "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
       "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
       "125263       -0.111009        0.041794        0.992940        -37.372594   \n",
       "\n",
       "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
       "21             14.997919        -20.075283       -0.150041        0.234536   \n",
       "22             14.997919        -20.075283       -0.150243        0.234115   \n",
       "23             14.997919        -20.075283       -0.150210        0.233747   \n",
       "39             14.997919        -20.075283       -0.149814        0.233510   \n",
       "40             14.997919        -20.075283       -0.149645        0.233258   \n",
       "...                  ...               ...             ...             ...   \n",
       "125259         14.763454        -23.294339       -0.130868        0.093021   \n",
       "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
       "125263         14.763454        -23.294339       -0.131320        0.092941   \n",
       "\n",
       "        gaze_normal1_z  \n",
       "21            0.960458  \n",
       "22            0.960530  \n",
       "23            0.960624  \n",
       "39            0.960744  \n",
       "40            0.960831  \n",
       "...                ...  \n",
       "125259        0.987026  \n",
       "125260        0.986979  \n",
       "125261        0.986979  \n",
       "125262        0.986827  \n",
       "125263        0.986974  \n",
       "\n",
       "[87442 rows x 21 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1 第一题\n",
    "df1= df.loc[[True if float(i) >= 0.9 else False for i in df['confidence'].tolist()],:]\n",
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3cdae2a",
   "metadata": {},
   "source": [
    "第二题、第三题在第一题的基础上处理"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6d1c5f63",
   "metadata": {},
   "source": [
    "第二题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ee3581b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "x1 = print(df1['norm_pos_x'].mean())\n",
    "x1\n",
    "y2 = print(df1['norm_pos_y'].mean())\n",
    "y2\n",
    "x3 = print(df1['norm_pos_x'].var())\n",
    "x3\n",
    "y4 = print(df1['norm_pos_y'].var())\n",
    "y4\n",
    "x1 = df1['norm_pos_x'].mean()+3*df1['norm_pos_x'].var()\n",
    "x2 = df1['norm_pos_x'].mean()-3*df1['norm_pos_x'].var()\n",
    "y1 = df1['norm_pos_y'].mean()+3*df1['norm_pos_y'].var()\n",
    "y2 = df1['norm_pos_y'].mean()-3*df1['norm_pos_y'].var()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "9d3b062b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gaze_timestamp</th>\n",
       "      <th>world_index</th>\n",
       "      <th>confidence</th>\n",
       "      <th>norm_pos_x</th>\n",
       "      <th>norm_pos_y</th>\n",
       "      <th>base_data</th>\n",
       "      <th>gaze_point_3d_x</th>\n",
       "      <th>gaze_point_3d_y</th>\n",
       "      <th>gaze_point_3d_z</th>\n",
       "      <th>eye_center0_3d_x</th>\n",
       "      <th>...</th>\n",
       "      <th>eye_center0_3d_z</th>\n",
       "      <th>gaze_normal0_x</th>\n",
       "      <th>gaze_normal0_y</th>\n",
       "      <th>gaze_normal0_z</th>\n",
       "      <th>eye_center1_3d_x</th>\n",
       "      <th>eye_center1_3d_y</th>\n",
       "      <th>eye_center1_3d_z</th>\n",
       "      <th>gaze_normal1_x</th>\n",
       "      <th>gaze_normal1_y</th>\n",
       "      <th>gaze_normal1_z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>88152.059441</td>\n",
       "      <td>39</td>\n",
       "      <td>0.936205</td>\n",
       "      <td>0.398812</td>\n",
       "      <td>0.415605</td>\n",
       "      <td>88152.059419-0 88152.05946399999-1</td>\n",
       "      <td>-614.974842</td>\n",
       "      <td>288.515053</td>\n",
       "      <td>4748.097241</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131778</td>\n",
       "      <td>0.071579</td>\n",
       "      <td>0.988692</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119526</td>\n",
       "      <td>0.042037</td>\n",
       "      <td>0.991941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>88152.061923</td>\n",
       "      <td>39</td>\n",
       "      <td>0.936205</td>\n",
       "      <td>0.398967</td>\n",
       "      <td>0.415841</td>\n",
       "      <td>88152.064382-0 88152.05946399999-1</td>\n",
       "      <td>-627.889437</td>\n",
       "      <td>294.199480</td>\n",
       "      <td>4855.216665</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119526</td>\n",
       "      <td>0.042037</td>\n",
       "      <td>0.991941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>88152.064382</td>\n",
       "      <td>39</td>\n",
       "      <td>0.938704</td>\n",
       "      <td>0.398925</td>\n",
       "      <td>0.415342</td>\n",
       "      <td>88152.064382-0 88152.064382-1</td>\n",
       "      <td>-637.325582</td>\n",
       "      <td>300.267015</td>\n",
       "      <td>4926.136171</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119698</td>\n",
       "      <td>0.042837</td>\n",
       "      <td>0.991886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>88152.067930</td>\n",
       "      <td>39</td>\n",
       "      <td>0.938704</td>\n",
       "      <td>0.399004</td>\n",
       "      <td>0.415731</td>\n",
       "      <td>88152.064382-0 88152.071478-1</td>\n",
       "      <td>-619.299497</td>\n",
       "      <td>290.660181</td>\n",
       "      <td>4790.572508</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119364</td>\n",
       "      <td>0.042105</td>\n",
       "      <td>0.991957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>88152.145476</td>\n",
       "      <td>42</td>\n",
       "      <td>0.904104</td>\n",
       "      <td>0.397420</td>\n",
       "      <td>0.415351</td>\n",
       "      <td>88152.147388-0 88152.14356499999-1</td>\n",
       "      <td>-577.986262</td>\n",
       "      <td>268.285258</td>\n",
       "      <td>4401.939117</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.133783</td>\n",
       "      <td>0.070785</td>\n",
       "      <td>0.988480</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.120578</td>\n",
       "      <td>0.042643</td>\n",
       "      <td>0.991787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125257</th>\n",
       "      <td>88443.692745</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.938922</td>\n",
       "      <td>0.407324</td>\n",
       "      <td>0.414699</td>\n",
       "      <td>88443.692747-0 88443.692744-1</td>\n",
       "      <td>322.200887</td>\n",
       "      <td>-166.814138</td>\n",
       "      <td>-2716.113303</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111356</td>\n",
       "      <td>0.041812</td>\n",
       "      <td>0.992901</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.131841</td>\n",
       "      <td>0.091543</td>\n",
       "      <td>0.987035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125258</th>\n",
       "      <td>88443.694169</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.999135</td>\n",
       "      <td>0.407554</td>\n",
       "      <td>0.413293</td>\n",
       "      <td>88443.692747-0 88443.695591-1</td>\n",
       "      <td>336.831550</td>\n",
       "      <td>-177.706680</td>\n",
       "      <td>-2846.522639</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111356</td>\n",
       "      <td>0.041812</td>\n",
       "      <td>0.992901</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.130868</td>\n",
       "      <td>0.093021</td>\n",
       "      <td>0.987026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125260</th>\n",
       "      <td>88443.697570</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.948733</td>\n",
       "      <td>0.407552</td>\n",
       "      <td>0.414731</td>\n",
       "      <td>88443.69561-0 88443.69953099999-1</td>\n",
       "      <td>311.054477</td>\n",
       "      <td>-161.381388</td>\n",
       "      <td>-2628.637408</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125261</th>\n",
       "      <td>88443.701580</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407467</td>\n",
       "      <td>0.414705</td>\n",
       "      <td>88443.703629-0 88443.69953099999-1</td>\n",
       "      <td>313.566509</td>\n",
       "      <td>-162.585330</td>\n",
       "      <td>-2647.420719</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125262</th>\n",
       "      <td>88443.703608</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407160</td>\n",
       "      <td>0.415340</td>\n",
       "      <td>88443.703629-0 88443.703587-1</td>\n",
       "      <td>297.019831</td>\n",
       "      <td>-152.352987</td>\n",
       "      <td>-2499.428189</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.133311</td>\n",
       "      <td>0.091656</td>\n",
       "      <td>0.986827</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2030 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
       "529       88152.059441           39    0.936205    0.398812    0.415605   \n",
       "530       88152.061923           39    0.936205    0.398967    0.415841   \n",
       "531       88152.064382           39    0.938704    0.398925    0.415342   \n",
       "532       88152.067930           39    0.938704    0.399004    0.415731   \n",
       "566       88152.145476           42    0.904104    0.397420    0.415351   \n",
       "...                ...          ...         ...         ...         ...   \n",
       "125257    88443.692745         8788    0.938922    0.407324    0.414699   \n",
       "125258    88443.694169         8788    0.999135    0.407554    0.413293   \n",
       "125260    88443.697570         8788    0.948733    0.407552    0.414731   \n",
       "125261    88443.701580         8788    0.945284    0.407467    0.414705   \n",
       "125262    88443.703608         8788    0.945284    0.407160    0.415340   \n",
       "\n",
       "                                 base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
       "529     88152.059419-0 88152.05946399999-1      -614.974842       288.515053   \n",
       "530     88152.064382-0 88152.05946399999-1      -627.889437       294.199480   \n",
       "531          88152.064382-0 88152.064382-1      -637.325582       300.267015   \n",
       "532          88152.064382-0 88152.071478-1      -619.299497       290.660181   \n",
       "566     88152.147388-0 88152.14356499999-1      -577.986262       268.285258   \n",
       "...                                    ...              ...              ...   \n",
       "125257       88443.692747-0 88443.692744-1       322.200887      -166.814138   \n",
       "125258       88443.692747-0 88443.695591-1       336.831550      -177.706680   \n",
       "125260   88443.69561-0 88443.69953099999-1       311.054477      -161.381388   \n",
       "125261  88443.703629-0 88443.69953099999-1       313.566509      -162.585330   \n",
       "125262       88443.703629-0 88443.703587-1       297.019831      -152.352987   \n",
       "\n",
       "        gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  \\\n",
       "529         4748.097241         20.000000  ...        -20.000000   \n",
       "530         4855.216665         20.000000  ...        -20.000000   \n",
       "531         4926.136171         20.000000  ...        -20.000000   \n",
       "532         4790.572508         20.000000  ...        -20.000000   \n",
       "566         4401.939117         20.000000  ...        -20.000000   \n",
       "...                 ...               ...  ...               ...   \n",
       "125257     -2716.113303         19.888755  ...        -20.707271   \n",
       "125258     -2846.522639         19.888755  ...        -20.707271   \n",
       "125260     -2628.637408         19.888755  ...        -20.707271   \n",
       "125261     -2647.420719         19.888755  ...        -20.707271   \n",
       "125262     -2499.428189         19.888755  ...        -20.707271   \n",
       "\n",
       "        gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  \\\n",
       "529          -0.131778        0.071579        0.988692        -39.934928   \n",
       "530          -0.131510        0.071395        0.988741        -39.934928   \n",
       "531          -0.131510        0.071395        0.988741        -39.934928   \n",
       "532          -0.131510        0.071395        0.988741        -39.934928   \n",
       "566          -0.133783        0.070785        0.988480        -39.934928   \n",
       "...                ...             ...             ...               ...   \n",
       "125257       -0.111356        0.041812        0.992901        -37.372594   \n",
       "125258       -0.111356        0.041812        0.992901        -37.372594   \n",
       "125260       -0.110854        0.041843        0.992955        -37.372594   \n",
       "125261       -0.111009        0.041794        0.992940        -37.372594   \n",
       "125262       -0.111009        0.041794        0.992940        -37.372594   \n",
       "\n",
       "        eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  \\\n",
       "529            14.997919        -20.075283       -0.119526        0.042037   \n",
       "530            14.997919        -20.075283       -0.119526        0.042037   \n",
       "531            14.997919        -20.075283       -0.119698        0.042837   \n",
       "532            14.997919        -20.075283       -0.119364        0.042105   \n",
       "566            14.997919        -20.075283       -0.120578        0.042643   \n",
       "...                  ...               ...             ...             ...   \n",
       "125257         14.763454        -23.294339       -0.131841        0.091543   \n",
       "125258         14.763454        -23.294339       -0.130868        0.093021   \n",
       "125260         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125261         14.763454        -23.294339       -0.132037        0.091860   \n",
       "125262         14.763454        -23.294339       -0.133311        0.091656   \n",
       "\n",
       "        gaze_normal1_z  \n",
       "529           0.991941  \n",
       "530           0.991941  \n",
       "531           0.991886  \n",
       "532           0.991957  \n",
       "566           0.991787  \n",
       "...                ...  \n",
       "125257        0.987035  \n",
       "125258        0.987026  \n",
       "125260        0.986979  \n",
       "125261        0.986979  \n",
       "125262        0.986827  \n",
       "\n",
       "[2030 rows x 21 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df1.loc[[True if float(i) >=y2 and float(i) <= y1 else False for i in df1['norm_pos_y'].tolist()],:]\n",
    "df2\n",
    "df_2 = df2.loc[[True if float(i) >=x2 and float(i) <= x1 else False for i in df2['norm_pos_x'].tolist()],:]\n",
    "df_2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6806bb07",
   "metadata": {},
   "source": [
    "第三题"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "62ac60a8",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gaze_timestamp</th>\n",
       "      <th>world_index</th>\n",
       "      <th>confidence</th>\n",
       "      <th>norm_pos_x</th>\n",
       "      <th>norm_pos_y</th>\n",
       "      <th>base_data</th>\n",
       "      <th>gaze_point_3d_x</th>\n",
       "      <th>gaze_point_3d_y</th>\n",
       "      <th>gaze_point_3d_z</th>\n",
       "      <th>eye_center0_3d_x</th>\n",
       "      <th>...</th>\n",
       "      <th>eye_center0_3d_z</th>\n",
       "      <th>gaze_normal0_x</th>\n",
       "      <th>gaze_normal0_y</th>\n",
       "      <th>gaze_normal0_z</th>\n",
       "      <th>eye_center1_3d_x</th>\n",
       "      <th>eye_center1_3d_y</th>\n",
       "      <th>eye_center1_3d_z</th>\n",
       "      <th>gaze_normal1_x</th>\n",
       "      <th>gaze_normal1_y</th>\n",
       "      <th>gaze_normal1_z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>529</th>\n",
       "      <td>1970-01-02 08:29:12.059441500+08:00</td>\n",
       "      <td>39</td>\n",
       "      <td>0.936205</td>\n",
       "      <td>0.398812</td>\n",
       "      <td>0.415605</td>\n",
       "      <td>88152.059419-0 88152.05946399999-1</td>\n",
       "      <td>-614.974842</td>\n",
       "      <td>288.515053</td>\n",
       "      <td>4748.097241</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131778</td>\n",
       "      <td>0.071579</td>\n",
       "      <td>0.988692</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119526</td>\n",
       "      <td>0.042037</td>\n",
       "      <td>0.991941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530</th>\n",
       "      <td>1970-01-02 08:29:12.061923+08:00</td>\n",
       "      <td>39</td>\n",
       "      <td>0.936205</td>\n",
       "      <td>0.398967</td>\n",
       "      <td>0.415841</td>\n",
       "      <td>88152.064382-0 88152.05946399999-1</td>\n",
       "      <td>-627.889437</td>\n",
       "      <td>294.199480</td>\n",
       "      <td>4855.216665</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119526</td>\n",
       "      <td>0.042037</td>\n",
       "      <td>0.991941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>531</th>\n",
       "      <td>1970-01-02 08:29:12.064382+08:00</td>\n",
       "      <td>39</td>\n",
       "      <td>0.938704</td>\n",
       "      <td>0.398925</td>\n",
       "      <td>0.415342</td>\n",
       "      <td>88152.064382-0 88152.064382-1</td>\n",
       "      <td>-637.325582</td>\n",
       "      <td>300.267015</td>\n",
       "      <td>4926.136171</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119698</td>\n",
       "      <td>0.042837</td>\n",
       "      <td>0.991886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>532</th>\n",
       "      <td>1970-01-02 08:29:12.067929999+08:00</td>\n",
       "      <td>39</td>\n",
       "      <td>0.938704</td>\n",
       "      <td>0.399004</td>\n",
       "      <td>0.415731</td>\n",
       "      <td>88152.064382-0 88152.071478-1</td>\n",
       "      <td>-619.299497</td>\n",
       "      <td>290.660181</td>\n",
       "      <td>4790.572508</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.131510</td>\n",
       "      <td>0.071395</td>\n",
       "      <td>0.988741</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.119364</td>\n",
       "      <td>0.042105</td>\n",
       "      <td>0.991957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>566</th>\n",
       "      <td>1970-01-02 08:29:12.145476500+08:00</td>\n",
       "      <td>42</td>\n",
       "      <td>0.904104</td>\n",
       "      <td>0.397420</td>\n",
       "      <td>0.415351</td>\n",
       "      <td>88152.147388-0 88152.14356499999-1</td>\n",
       "      <td>-577.986262</td>\n",
       "      <td>268.285258</td>\n",
       "      <td>4401.939117</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>-0.133783</td>\n",
       "      <td>0.070785</td>\n",
       "      <td>0.988480</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.120578</td>\n",
       "      <td>0.042643</td>\n",
       "      <td>0.991787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125257</th>\n",
       "      <td>1970-01-02 08:34:03.692745500+08:00</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.938922</td>\n",
       "      <td>0.407324</td>\n",
       "      <td>0.414699</td>\n",
       "      <td>88443.692747-0 88443.692744-1</td>\n",
       "      <td>322.200887</td>\n",
       "      <td>-166.814138</td>\n",
       "      <td>-2716.113303</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111356</td>\n",
       "      <td>0.041812</td>\n",
       "      <td>0.992901</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.131841</td>\n",
       "      <td>0.091543</td>\n",
       "      <td>0.987035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125258</th>\n",
       "      <td>1970-01-02 08:34:03.694169+08:00</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.999135</td>\n",
       "      <td>0.407554</td>\n",
       "      <td>0.413293</td>\n",
       "      <td>88443.692747-0 88443.695591-1</td>\n",
       "      <td>336.831550</td>\n",
       "      <td>-177.706680</td>\n",
       "      <td>-2846.522639</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111356</td>\n",
       "      <td>0.041812</td>\n",
       "      <td>0.992901</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.130868</td>\n",
       "      <td>0.093021</td>\n",
       "      <td>0.987026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125260</th>\n",
       "      <td>1970-01-02 08:34:03.697570500+08:00</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.948733</td>\n",
       "      <td>0.407552</td>\n",
       "      <td>0.414731</td>\n",
       "      <td>88443.69561-0 88443.69953099999-1</td>\n",
       "      <td>311.054477</td>\n",
       "      <td>-161.381388</td>\n",
       "      <td>-2628.637408</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.110854</td>\n",
       "      <td>0.041843</td>\n",
       "      <td>0.992955</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125261</th>\n",
       "      <td>1970-01-02 08:34:03.701580+08:00</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407467</td>\n",
       "      <td>0.414705</td>\n",
       "      <td>88443.703629-0 88443.69953099999-1</td>\n",
       "      <td>313.566509</td>\n",
       "      <td>-162.585330</td>\n",
       "      <td>-2647.420719</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.132037</td>\n",
       "      <td>0.091860</td>\n",
       "      <td>0.986979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125262</th>\n",
       "      <td>1970-01-02 08:34:03.703608+08:00</td>\n",
       "      <td>8788</td>\n",
       "      <td>0.945284</td>\n",
       "      <td>0.407160</td>\n",
       "      <td>0.415340</td>\n",
       "      <td>88443.703629-0 88443.703587-1</td>\n",
       "      <td>297.019831</td>\n",
       "      <td>-152.352987</td>\n",
       "      <td>-2499.428189</td>\n",
       "      <td>19.888755</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.707271</td>\n",
       "      <td>-0.111009</td>\n",
       "      <td>0.041794</td>\n",
       "      <td>0.992940</td>\n",
       "      <td>-37.372594</td>\n",
       "      <td>14.763454</td>\n",
       "      <td>-23.294339</td>\n",
       "      <td>-0.133311</td>\n",
       "      <td>0.091656</td>\n",
       "      <td>0.986827</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2030 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            gaze_timestamp  world_index  confidence  \\\n",
       "529    1970-01-02 08:29:12.059441500+08:00           39    0.936205   \n",
       "530       1970-01-02 08:29:12.061923+08:00           39    0.936205   \n",
       "531       1970-01-02 08:29:12.064382+08:00           39    0.938704   \n",
       "532    1970-01-02 08:29:12.067929999+08:00           39    0.938704   \n",
       "566    1970-01-02 08:29:12.145476500+08:00           42    0.904104   \n",
       "...                                    ...          ...         ...   \n",
       "125257 1970-01-02 08:34:03.692745500+08:00         8788    0.938922   \n",
       "125258    1970-01-02 08:34:03.694169+08:00         8788    0.999135   \n",
       "125260 1970-01-02 08:34:03.697570500+08:00         8788    0.948733   \n",
       "125261    1970-01-02 08:34:03.701580+08:00         8788    0.945284   \n",
       "125262    1970-01-02 08:34:03.703608+08:00         8788    0.945284   \n",
       "\n",
       "        norm_pos_x  norm_pos_y                           base_data  \\\n",
       "529       0.398812    0.415605  88152.059419-0 88152.05946399999-1   \n",
       "530       0.398967    0.415841  88152.064382-0 88152.05946399999-1   \n",
       "531       0.398925    0.415342       88152.064382-0 88152.064382-1   \n",
       "532       0.399004    0.415731       88152.064382-0 88152.071478-1   \n",
       "566       0.397420    0.415351  88152.147388-0 88152.14356499999-1   \n",
       "...            ...         ...                                 ...   \n",
       "125257    0.407324    0.414699       88443.692747-0 88443.692744-1   \n",
       "125258    0.407554    0.413293       88443.692747-0 88443.695591-1   \n",
       "125260    0.407552    0.414731   88443.69561-0 88443.69953099999-1   \n",
       "125261    0.407467    0.414705  88443.703629-0 88443.69953099999-1   \n",
       "125262    0.407160    0.415340       88443.703629-0 88443.703587-1   \n",
       "\n",
       "        gaze_point_3d_x  gaze_point_3d_y  gaze_point_3d_z  eye_center0_3d_x  \\\n",
       "529         -614.974842       288.515053      4748.097241         20.000000   \n",
       "530         -627.889437       294.199480      4855.216665         20.000000   \n",
       "531         -637.325582       300.267015      4926.136171         20.000000   \n",
       "532         -619.299497       290.660181      4790.572508         20.000000   \n",
       "566         -577.986262       268.285258      4401.939117         20.000000   \n",
       "...                 ...              ...              ...               ...   \n",
       "125257       322.200887      -166.814138     -2716.113303         19.888755   \n",
       "125258       336.831550      -177.706680     -2846.522639         19.888755   \n",
       "125260       311.054477      -161.381388     -2628.637408         19.888755   \n",
       "125261       313.566509      -162.585330     -2647.420719         19.888755   \n",
       "125262       297.019831      -152.352987     -2499.428189         19.888755   \n",
       "\n",
       "        ...  eye_center0_3d_z  gaze_normal0_x  gaze_normal0_y  gaze_normal0_z  \\\n",
       "529     ...        -20.000000       -0.131778        0.071579        0.988692   \n",
       "530     ...        -20.000000       -0.131510        0.071395        0.988741   \n",
       "531     ...        -20.000000       -0.131510        0.071395        0.988741   \n",
       "532     ...        -20.000000       -0.131510        0.071395        0.988741   \n",
       "566     ...        -20.000000       -0.133783        0.070785        0.988480   \n",
       "...     ...               ...             ...             ...             ...   \n",
       "125257  ...        -20.707271       -0.111356        0.041812        0.992901   \n",
       "125258  ...        -20.707271       -0.111356        0.041812        0.992901   \n",
       "125260  ...        -20.707271       -0.110854        0.041843        0.992955   \n",
       "125261  ...        -20.707271       -0.111009        0.041794        0.992940   \n",
       "125262  ...        -20.707271       -0.111009        0.041794        0.992940   \n",
       "\n",
       "        eye_center1_3d_x  eye_center1_3d_y  eye_center1_3d_z  gaze_normal1_x  \\\n",
       "529           -39.934928         14.997919        -20.075283       -0.119526   \n",
       "530           -39.934928         14.997919        -20.075283       -0.119526   \n",
       "531           -39.934928         14.997919        -20.075283       -0.119698   \n",
       "532           -39.934928         14.997919        -20.075283       -0.119364   \n",
       "566           -39.934928         14.997919        -20.075283       -0.120578   \n",
       "...                  ...               ...               ...             ...   \n",
       "125257        -37.372594         14.763454        -23.294339       -0.131841   \n",
       "125258        -37.372594         14.763454        -23.294339       -0.130868   \n",
       "125260        -37.372594         14.763454        -23.294339       -0.132037   \n",
       "125261        -37.372594         14.763454        -23.294339       -0.132037   \n",
       "125262        -37.372594         14.763454        -23.294339       -0.133311   \n",
       "\n",
       "        gaze_normal1_y  gaze_normal1_z  \n",
       "529           0.042037        0.991941  \n",
       "530           0.042037        0.991941  \n",
       "531           0.042837        0.991886  \n",
       "532           0.042105        0.991957  \n",
       "566           0.042643        0.991787  \n",
       "...                ...             ...  \n",
       "125257        0.091543        0.987035  \n",
       "125258        0.093021        0.987026  \n",
       "125260        0.091860        0.986979  \n",
       "125261        0.091860        0.986979  \n",
       "125262        0.091656        0.986827  \n",
       "\n",
       "[2030 rows x 21 columns]"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('mode.chained_assignment', None)#关闭警告\n",
    "\n",
    "df_2['gaze_timestamp']=pd.to_datetime(df_2['gaze_timestamp'].values,utc=True,unit='s').tz_convert('Asia/Shanghai')\n",
    "df_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0148dfa8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "427.6226938619197"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#第四题\n",
    "x = []\n",
    "y = []\n",
    "for i in df['gaze_timestamp']:\n",
    "    \n",
    "    x.append(i)\n",
    "\n",
    "x = [(x[i+1]-x[i]) for i in range(len(x)-1)]\n",
    "x\n",
    "sum(x)\n",
    "length = len(x)\n",
    "ans = length/sum(x)\n",
    "ans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "d400e9d9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gaze_timestamp</th>\n",
       "      <th>world_index</th>\n",
       "      <th>confidence</th>\n",
       "      <th>norm_pos_x</th>\n",
       "      <th>norm_pos_y</th>\n",
       "      <th>base_data</th>\n",
       "      <th>gaze_point_3d_x</th>\n",
       "      <th>gaze_point_3d_y</th>\n",
       "      <th>gaze_point_3d_z</th>\n",
       "      <th>eye_center0_3d_x</th>\n",
       "      <th>...</th>\n",
       "      <th>eye_center0_3d_z</th>\n",
       "      <th>gaze_normal0_x</th>\n",
       "      <th>gaze_normal0_y</th>\n",
       "      <th>gaze_normal0_z</th>\n",
       "      <th>eye_center1_3d_x</th>\n",
       "      <th>eye_center1_3d_y</th>\n",
       "      <th>eye_center1_3d_z</th>\n",
       "      <th>gaze_normal1_x</th>\n",
       "      <th>gaze_normal1_y</th>\n",
       "      <th>gaze_normal1_z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>88150.77678</td>\n",
       "      <td>0</td>\n",
       "      <td>0.828006</td>\n",
       "      <td>0.531433</td>\n",
       "      <td>0.397509</td>\n",
       "      <td>88150.77678-0</td>\n",
       "      <td>28.369753</td>\n",
       "      <td>52.033135</td>\n",
       "      <td>705.121116</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.011527</td>\n",
       "      <td>0.051002</td>\n",
       "      <td>0.998632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>88150.78678</td>\n",
       "      <td>0</td>\n",
       "      <td>0.459705</td>\n",
       "      <td>0.337051</td>\n",
       "      <td>0.186147</td>\n",
       "      <td>88150.776787-1</td>\n",
       "      <td>-142.869866</td>\n",
       "      <td>154.788121</td>\n",
       "      <td>684.981621</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.141761</td>\n",
       "      <td>0.192518</td>\n",
       "      <td>0.971000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>88150.79678</td>\n",
       "      <td>0</td>\n",
       "      <td>0.888789</td>\n",
       "      <td>0.543140</td>\n",
       "      <td>0.410668</td>\n",
       "      <td>88150.779709-0</td>\n",
       "      <td>38.942051</td>\n",
       "      <td>45.359863</td>\n",
       "      <td>705.232112</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.026087</td>\n",
       "      <td>0.041811</td>\n",
       "      <td>0.998785</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>88150.80678</td>\n",
       "      <td>0</td>\n",
       "      <td>0.550258</td>\n",
       "      <td>0.337923</td>\n",
       "      <td>0.173301</td>\n",
       "      <td>88150.779759-1</td>\n",
       "      <td>-141.879169</td>\n",
       "      <td>160.867779</td>\n",
       "      <td>683.893108</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.140397</td>\n",
       "      <td>0.200891</td>\n",
       "      <td>0.969501</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>88150.81678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.502595</td>\n",
       "      <td>0.340109</td>\n",
       "      <td>0.142989</td>\n",
       "      <td>88150.787485-1</td>\n",
       "      <td>-139.404860</td>\n",
       "      <td>175.088321</td>\n",
       "      <td>681.151453</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.136989</td>\n",
       "      <td>0.220475</td>\n",
       "      <td>0.965725</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>88150.82678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.625134</td>\n",
       "      <td>0.484139</td>\n",
       "      <td>0.385491</td>\n",
       "      <td>88150.78368299999-0 88150.79147699999-1</td>\n",
       "      <td>6.784204</td>\n",
       "      <td>-27.550520</td>\n",
       "      <td>-334.161525</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.041430</td>\n",
       "      <td>0.034837</td>\n",
       "      <td>0.998534</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.145087</td>\n",
       "      <td>0.230744</td>\n",
       "      <td>0.962137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>88150.83678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.625134</td>\n",
       "      <td>0.489687</td>\n",
       "      <td>0.392849</td>\n",
       "      <td>88150.787484-0 88150.79147699999-1</td>\n",
       "      <td>4.180437</td>\n",
       "      <td>-24.431546</td>\n",
       "      <td>-316.680240</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.052495</td>\n",
       "      <td>0.029825</td>\n",
       "      <td>0.998176</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.145087</td>\n",
       "      <td>0.230744</td>\n",
       "      <td>0.962137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>88150.84678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.625134</td>\n",
       "      <td>0.495993</td>\n",
       "      <td>0.399021</td>\n",
       "      <td>88150.79569-0 88150.79147699999-1</td>\n",
       "      <td>1.533100</td>\n",
       "      <td>-21.730862</td>\n",
       "      <td>-298.890441</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.065145</td>\n",
       "      <td>0.027374</td>\n",
       "      <td>0.997500</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.145087</td>\n",
       "      <td>0.230744</td>\n",
       "      <td>0.962137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>88150.85678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.706355</td>\n",
       "      <td>0.493975</td>\n",
       "      <td>0.408429</td>\n",
       "      <td>88150.79569-0 88150.795675-1</td>\n",
       "      <td>2.226758</td>\n",
       "      <td>-19.036160</td>\n",
       "      <td>-288.727225</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.065145</td>\n",
       "      <td>0.027374</td>\n",
       "      <td>0.997500</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.153085</td>\n",
       "      <td>0.220988</td>\n",
       "      <td>0.963187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>88150.86678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.708476</td>\n",
       "      <td>0.494116</td>\n",
       "      <td>0.407109</td>\n",
       "      <td>88150.79569-0 88150.801123-1</td>\n",
       "      <td>2.179629</td>\n",
       "      <td>-19.354530</td>\n",
       "      <td>-289.386597</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.065145</td>\n",
       "      <td>0.027374</td>\n",
       "      <td>0.997500</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152523</td>\n",
       "      <td>0.222659</td>\n",
       "      <td>0.962891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>88150.87678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.708476</td>\n",
       "      <td>0.495145</td>\n",
       "      <td>0.408338</td>\n",
       "      <td>88150.801157-0 88150.801123-1</td>\n",
       "      <td>1.782444</td>\n",
       "      <td>-18.930993</td>\n",
       "      <td>-286.849309</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.067222</td>\n",
       "      <td>0.026625</td>\n",
       "      <td>0.997383</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152523</td>\n",
       "      <td>0.222659</td>\n",
       "      <td>0.962891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>88150.88678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.839662</td>\n",
       "      <td>0.495216</td>\n",
       "      <td>0.403442</td>\n",
       "      <td>88150.801157-0 88150.80479-1</td>\n",
       "      <td>1.757366</td>\n",
       "      <td>-19.951730</td>\n",
       "      <td>-286.984799</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.067222</td>\n",
       "      <td>0.026625</td>\n",
       "      <td>0.997383</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152228</td>\n",
       "      <td>0.229814</td>\n",
       "      <td>0.961255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>88150.89678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.791032</td>\n",
       "      <td>0.494728</td>\n",
       "      <td>0.405146</td>\n",
       "      <td>88150.804471-0 88150.80479-1</td>\n",
       "      <td>1.944664</td>\n",
       "      <td>-19.682136</td>\n",
       "      <td>-288.194181</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.066239</td>\n",
       "      <td>0.023518</td>\n",
       "      <td>0.997527</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152228</td>\n",
       "      <td>0.229814</td>\n",
       "      <td>0.961255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>88150.90678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.856341</td>\n",
       "      <td>0.494777</td>\n",
       "      <td>0.404969</td>\n",
       "      <td>88150.809749-0 88150.80479-1</td>\n",
       "      <td>1.925755</td>\n",
       "      <td>-19.710658</td>\n",
       "      <td>-288.072115</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.066338</td>\n",
       "      <td>0.023840</td>\n",
       "      <td>0.997512</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152228</td>\n",
       "      <td>0.229814</td>\n",
       "      <td>0.961255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>88150.91678</td>\n",
       "      <td>1</td>\n",
       "      <td>0.856341</td>\n",
       "      <td>0.494888</td>\n",
       "      <td>0.402216</td>\n",
       "      <td>88150.809749-0 88150.809748-1</td>\n",
       "      <td>1.887678</td>\n",
       "      <td>-20.312303</td>\n",
       "      <td>-288.507800</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.066338</td>\n",
       "      <td>0.023840</td>\n",
       "      <td>0.997512</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.151781</td>\n",
       "      <td>0.233679</td>\n",
       "      <td>0.960394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>88150.92678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.856341</td>\n",
       "      <td>0.494809</td>\n",
       "      <td>0.402125</td>\n",
       "      <td>88150.809749-0 88150.815997-1</td>\n",
       "      <td>1.914321</td>\n",
       "      <td>-20.302480</td>\n",
       "      <td>-288.102445</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.066338</td>\n",
       "      <td>0.023840</td>\n",
       "      <td>0.997512</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152094</td>\n",
       "      <td>0.233980</td>\n",
       "      <td>0.960271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>88150.93678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.716398</td>\n",
       "      <td>0.494057</td>\n",
       "      <td>0.401233</td>\n",
       "      <td>88150.81227499999-0 88150.815997-1</td>\n",
       "      <td>2.205674</td>\n",
       "      <td>-20.620175</td>\n",
       "      <td>-289.966778</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.064824</td>\n",
       "      <td>0.024375</td>\n",
       "      <td>0.997599</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152094</td>\n",
       "      <td>0.233980</td>\n",
       "      <td>0.960271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>88150.94678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.836166</td>\n",
       "      <td>0.493629</td>\n",
       "      <td>0.400583</td>\n",
       "      <td>88150.81599799999-0 88150.815997-1</td>\n",
       "      <td>2.373377</td>\n",
       "      <td>-20.832665</td>\n",
       "      <td>-291.039161</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.063962</td>\n",
       "      <td>0.024893</td>\n",
       "      <td>0.997642</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.152094</td>\n",
       "      <td>0.233980</td>\n",
       "      <td>0.960271</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>88150.95678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.836166</td>\n",
       "      <td>0.493772</td>\n",
       "      <td>0.400270</td>\n",
       "      <td>88150.81599799999-0 88150.820104-1</td>\n",
       "      <td>2.325815</td>\n",
       "      <td>-20.950335</td>\n",
       "      <td>-291.765325</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.063962</td>\n",
       "      <td>0.024893</td>\n",
       "      <td>0.997642</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.151527</td>\n",
       "      <td>0.234143</td>\n",
       "      <td>0.960321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>88150.96678</td>\n",
       "      <td>2</td>\n",
       "      <td>0.861113</td>\n",
       "      <td>0.493453</td>\n",
       "      <td>0.399839</td>\n",
       "      <td>88150.823534-0 88150.820104-1</td>\n",
       "      <td>2.451823</td>\n",
       "      <td>-21.099370</td>\n",
       "      <td>-292.574406</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>-20.000000</td>\n",
       "      <td>0.063320</td>\n",
       "      <td>0.025199</td>\n",
       "      <td>0.997675</td>\n",
       "      <td>-39.934928</td>\n",
       "      <td>14.997919</td>\n",
       "      <td>-20.075283</td>\n",
       "      <td>-0.151527</td>\n",
       "      <td>0.234143</td>\n",
       "      <td>0.960321</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    gaze_timestamp  world_index  confidence  norm_pos_x  norm_pos_y  \\\n",
       "0      88150.77678            0    0.828006    0.531433    0.397509   \n",
       "1      88150.78678            0    0.459705    0.337051    0.186147   \n",
       "2      88150.79678            0    0.888789    0.543140    0.410668   \n",
       "3      88150.80678            0    0.550258    0.337923    0.173301   \n",
       "4      88150.81678            1    0.502595    0.340109    0.142989   \n",
       "5      88150.82678            1    0.625134    0.484139    0.385491   \n",
       "6      88150.83678            1    0.625134    0.489687    0.392849   \n",
       "7      88150.84678            1    0.625134    0.495993    0.399021   \n",
       "8      88150.85678            1    0.706355    0.493975    0.408429   \n",
       "9      88150.86678            1    0.708476    0.494116    0.407109   \n",
       "10     88150.87678            1    0.708476    0.495145    0.408338   \n",
       "11     88150.88678            1    0.839662    0.495216    0.403442   \n",
       "12     88150.89678            1    0.791032    0.494728    0.405146   \n",
       "13     88150.90678            1    0.856341    0.494777    0.404969   \n",
       "14     88150.91678            1    0.856341    0.494888    0.402216   \n",
       "15     88150.92678            2    0.856341    0.494809    0.402125   \n",
       "16     88150.93678            2    0.716398    0.494057    0.401233   \n",
       "17     88150.94678            2    0.836166    0.493629    0.400583   \n",
       "18     88150.95678            2    0.836166    0.493772    0.400270   \n",
       "19     88150.96678            2    0.861113    0.493453    0.399839   \n",
       "\n",
       "                                  base_data  gaze_point_3d_x  gaze_point_3d_y  \\\n",
       "0                             88150.77678-0        28.369753        52.033135   \n",
       "1                            88150.776787-1      -142.869866       154.788121   \n",
       "2                            88150.779709-0        38.942051        45.359863   \n",
       "3                            88150.779759-1      -141.879169       160.867779   \n",
       "4                            88150.787485-1      -139.404860       175.088321   \n",
       "5   88150.78368299999-0 88150.79147699999-1         6.784204       -27.550520   \n",
       "6        88150.787484-0 88150.79147699999-1         4.180437       -24.431546   \n",
       "7         88150.79569-0 88150.79147699999-1         1.533100       -21.730862   \n",
       "8              88150.79569-0 88150.795675-1         2.226758       -19.036160   \n",
       "9              88150.79569-0 88150.801123-1         2.179629       -19.354530   \n",
       "10            88150.801157-0 88150.801123-1         1.782444       -18.930993   \n",
       "11             88150.801157-0 88150.80479-1         1.757366       -19.951730   \n",
       "12             88150.804471-0 88150.80479-1         1.944664       -19.682136   \n",
       "13             88150.809749-0 88150.80479-1         1.925755       -19.710658   \n",
       "14            88150.809749-0 88150.809748-1         1.887678       -20.312303   \n",
       "15            88150.809749-0 88150.815997-1         1.914321       -20.302480   \n",
       "16       88150.81227499999-0 88150.815997-1         2.205674       -20.620175   \n",
       "17       88150.81599799999-0 88150.815997-1         2.373377       -20.832665   \n",
       "18       88150.81599799999-0 88150.820104-1         2.325815       -20.950335   \n",
       "19            88150.823534-0 88150.820104-1         2.451823       -21.099370   \n",
       "\n",
       "    gaze_point_3d_z  eye_center0_3d_x  ...  eye_center0_3d_z  gaze_normal0_x  \\\n",
       "0        705.121116         20.000000  ...        -20.000000        0.011527   \n",
       "1        684.981621        -39.934928  ...        -20.075283       -0.141761   \n",
       "2        705.232112         20.000000  ...        -20.000000        0.026087   \n",
       "3        683.893108        -39.934928  ...        -20.075283       -0.140397   \n",
       "4        681.151453        -39.934928  ...        -20.075283       -0.136989   \n",
       "5       -334.161525         20.000000  ...        -20.000000        0.041430   \n",
       "6       -316.680240         20.000000  ...        -20.000000        0.052495   \n",
       "7       -298.890441         20.000000  ...        -20.000000        0.065145   \n",
       "8       -288.727225         20.000000  ...        -20.000000        0.065145   \n",
       "9       -289.386597         20.000000  ...        -20.000000        0.065145   \n",
       "10      -286.849309         20.000000  ...        -20.000000        0.067222   \n",
       "11      -286.984799         20.000000  ...        -20.000000        0.067222   \n",
       "12      -288.194181         20.000000  ...        -20.000000        0.066239   \n",
       "13      -288.072115         20.000000  ...        -20.000000        0.066338   \n",
       "14      -288.507800         20.000000  ...        -20.000000        0.066338   \n",
       "15      -288.102445         20.000000  ...        -20.000000        0.066338   \n",
       "16      -289.966778         20.000000  ...        -20.000000        0.064824   \n",
       "17      -291.039161         20.000000  ...        -20.000000        0.063962   \n",
       "18      -291.765325         20.000000  ...        -20.000000        0.063962   \n",
       "19      -292.574406         20.000000  ...        -20.000000        0.063320   \n",
       "\n",
       "    gaze_normal0_y  gaze_normal0_z  eye_center1_3d_x  eye_center1_3d_y  \\\n",
       "0         0.051002        0.998632               NaN               NaN   \n",
       "1         0.192518        0.971000               NaN               NaN   \n",
       "2         0.041811        0.998785               NaN               NaN   \n",
       "3         0.200891        0.969501               NaN               NaN   \n",
       "4         0.220475        0.965725               NaN               NaN   \n",
       "5         0.034837        0.998534        -39.934928         14.997919   \n",
       "6         0.029825        0.998176        -39.934928         14.997919   \n",
       "7         0.027374        0.997500        -39.934928         14.997919   \n",
       "8         0.027374        0.997500        -39.934928         14.997919   \n",
       "9         0.027374        0.997500        -39.934928         14.997919   \n",
       "10        0.026625        0.997383        -39.934928         14.997919   \n",
       "11        0.026625        0.997383        -39.934928         14.997919   \n",
       "12        0.023518        0.997527        -39.934928         14.997919   \n",
       "13        0.023840        0.997512        -39.934928         14.997919   \n",
       "14        0.023840        0.997512        -39.934928         14.997919   \n",
       "15        0.023840        0.997512        -39.934928         14.997919   \n",
       "16        0.024375        0.997599        -39.934928         14.997919   \n",
       "17        0.024893        0.997642        -39.934928         14.997919   \n",
       "18        0.024893        0.997642        -39.934928         14.997919   \n",
       "19        0.025199        0.997675        -39.934928         14.997919   \n",
       "\n",
       "    eye_center1_3d_z  gaze_normal1_x  gaze_normal1_y  gaze_normal1_z  \n",
       "0                NaN             NaN             NaN             NaN  \n",
       "1                NaN             NaN             NaN             NaN  \n",
       "2                NaN             NaN             NaN             NaN  \n",
       "3                NaN             NaN             NaN             NaN  \n",
       "4                NaN             NaN             NaN             NaN  \n",
       "5         -20.075283       -0.145087        0.230744        0.962137  \n",
       "6         -20.075283       -0.145087        0.230744        0.962137  \n",
       "7         -20.075283       -0.145087        0.230744        0.962137  \n",
       "8         -20.075283       -0.153085        0.220988        0.963187  \n",
       "9         -20.075283       -0.152523        0.222659        0.962891  \n",
       "10        -20.075283       -0.152523        0.222659        0.962891  \n",
       "11        -20.075283       -0.152228        0.229814        0.961255  \n",
       "12        -20.075283       -0.152228        0.229814        0.961255  \n",
       "13        -20.075283       -0.152228        0.229814        0.961255  \n",
       "14        -20.075283       -0.151781        0.233679        0.960394  \n",
       "15        -20.075283       -0.152094        0.233980        0.960271  \n",
       "16        -20.075283       -0.152094        0.233980        0.960271  \n",
       "17        -20.075283       -0.152094        0.233980        0.960271  \n",
       "18        -20.075283       -0.151527        0.234143        0.960321  \n",
       "19        -20.075283       -0.151527        0.234143        0.960321  \n",
       "\n",
       "[20 rows x 21 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#第五题\n",
    "ans3 = 1/100\n",
    "first = df['gaze_timestamp'][0]\n",
    "lst = []\n",
    "x = first\n",
    "lst.append(x)\n",
    "\n",
    "for i in range(length):\n",
    "    x = ans3 + x    \n",
    "    lst.append(x)\n",
    "\n",
    "df[\"gaze_timestamp\"] = lst\n",
    "df[0:20]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
